home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Power Programmierung
/
Power-Programmierung (Tewi)(1994).iso
/
magazine
/
dbms_mag
/
9108
/
roti3.aug
< prev
next >
Wrap
Text File
|
1991-06-27
|
2KB
|
57 lines
Listing 3:
SQL> SELECT * FROM accounts;
ACCOUN ACCOUNT_NAME CREDIT_LIMIT CREDIT_USED
------ -------------------- ------------ -----------
111222 John Dough 2000 1000
222333 Johnny Cash 3000 1000
SQL> SELECT * FROM transactions;
TRANSACTION_NUMBER ACCOUN T AMOUNT P
------------------ ------ - ------- -
1 111222 P 100 N
2 222333 P 200 N
3 222333 C 300 N
4 999999 P 400 N
5 111222 X 500 N
6 111222 P 100000 N
7 111222 C 200000 N
SQL> SELECT * FROM errors;
no rows selected
SQL> @trans.sql
PL/SQL procedure successfully completed.
SQL> SELECT * FROM accounts;
ACCOUN ACCOUNT_NAME CREDIT_LIMIT CREDIT_USED
------ -------------------- ------------ -----------
111222 John Dough 2000 1100
222333 Johnny Cash 3000 900
SQL> SELECT * FROM transactions;
TRANSACTION_NUMBER ACCOUN T AMOUNT P
------------------ ------ - ------- -
1 111222 P 100 Y
2 222333 P 200 Y
3 222333 C 300 Y
4 999999 P 400 N
5 111222 X 500 N
6 111222 P 100000 N
7 111222 C 200000 N
SQL> SELECT * FROM errors;
TRANSACTION_NUMBER ERROR_MESSAGE
------------------ ------------------------------
4 Invalid account: 999999
5 Invalid type: X
6 Purchase too big: 100000
7 Payment too big: 200000